FO_Reports

Rhodes Group has provided standard reports, each is a record in this table.

If the SSRS report function is used to custom design reports, those reports need to be added to this table.

 

Field Type Notes

ReqOp_TID

int

ID field, a counter. Unique

CommonName

varchar(50)

Short Name for report. Displays in report list.

IE: Blank ABN

Description

varchar(80)

Expanded report name. Displays in report list.

IE: Blank ABN Form

ReportName

varchar(50)

Character string, or code, referenced by software.

Enter a short string with no spaces.

IE: ReportBlankABN

Seq

int

Used to sort the report list.

Enter an integer to indicate where this report should be in the report list.

Optional

ReportType

varchar(50)

Identifies the report type.

Enter an allowed value.

Allowed values:

MAIN

ORDER

PATIENT

ANY

UserPermGroup

varchar(500)

Permissions group(s) that can use this report.

Multidimensional pipe delimited value, with leading and trailing pipes.

Enter valid permgroup codes separated by pipes.

Enter |ALL| if available to all permission groups.

DisplayPrompts

varchar(50)

Determines which prompts are presented to the user when a report is invoked.

Enter one or more characters from the allowed values.

Allowed values:

1 = starting date/time range

2 = ending date/time range

P = patient fields

A = accession fields

C = client code

D = provider code

L = location code

T = container fields

IE: 12PACDL

Date1Default

varchar(50)

Default start date.

Enter a valid date in MM/DD/YYYY format.

Enter NOW to default to current date.

Time1Default

varchar(50)

Default start time.

Enter a valid time in HH:MM 24-hour format.

Enter NOW to default to current time.

Date2Default

varchar(50)

Default end date.

Enter a valid date in MM/DD/YYYY format.

Skip this entry to default to current date.

Time2Default

varchar(50)

Default end time.

Enter a valid time in HH:MM 24-hour format.

Skip this entry to default to 23:59.

PtFOIDDefault

varchar(50)

Default valid FOID.

Enter a valid patient FOID or an allowed value.

Skip this entry to default to no value. The patient record that the user is in when calling this report will be used for the report.

Allowed values:

FOID = default to current patient. This patient will always be used when this report is called.

AccessionDefault

varchar(50)

Default accession.

Enter a valid FAST Accession or an allowed value.

Skip this entry to default to no value.

Allowed values:

ACCESSION = default to current accession in memory

ClientIdDefault

varchar(50)

Default client ID.

Enter a valid client ID or an allowed value.

Skip this entry to default to no value.

Allowed values:

CURRENT = default to current client ID in memory

PhysCodeDefault

varchar(50)

Default provider code.

Enter a valid provider code or an allowed value.

Skip this entry to default to no value.

Allowed values:

CURRENT = default to current provider code in memory

USERDEFAULT = default to the user-level default value

LocationCodeDefault

varchar(50)

Default location code.

Enter a valid location code or an allowed value.

Skip this entry to default to no value.

Allowed values:

CURRENT = default to current location code in memory

USERDEFAULT = default to the user-level default value

DEVICELOCATION = default device location user entered at logon

ReportTitleDefault

varchar(80)

Default report title.

Enter a report title to display on report.

Skip this entry to use the common name as the report name.

ReportQuery

varchar(4000)

Enter SQL select statement for report.

ReportOutcome

varchar(50)

Future Use

SSRSURL

varchar(500)

Enter EF = Expired Orders

Instructs system to look in the FO_External_Form_Definition table for more definitions and/or a link to an external report URL in the FO_External_Form_Definition.ReportURL field.